<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<!DOCTYPE html>
<html>
<head>
    <sql:setDataSource var="snapshot" driver="com.mysql.cj.jdbc.Driver"
	url="jdbc:mysql://localhost:3306/${ SqlName }?useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC"
	user="${ SqlUser }"  password="${ SqlPass }"/>
		    <sql:query dataSource="${snapshot}" var="result">
				SELECT *  FROM user_index WHERE user_id = ${ SeeUserid }
			</sql:query>
<meta charset="UTF-8">
<title><c:forEach var="row" items="${ result.rows }">${ row.user_name }的动态</c:forEach></title>
		<link rel="icon" href="img/title.ico" type="image/x-icon">
	    <link href="https://fonts.googleapis.com/css?family=Muli:300,400,500,600,700,800,900&display=swap" rel="stylesheet">
	    <link rel="stylesheet" href="css/bootstrap.min.css" type="text/css">
	    <link rel="stylesheet" href="css/font-awesome.min.css" type="text/css">
	    <link rel="stylesheet" href="css/themify-icons.css" type="text/css">
	    <link rel="stylesheet" href="css/elegant-icons.css" type="text/css">
	    <link rel="stylesheet" href="css/owl.carousel.min.css" type="text/css">
	    <link rel="stylesheet" href="css/nice-select.css" type="text/css">
	    <link rel="stylesheet" href="css/jquery-ui.min.css" type="text/css">
	    <link rel="stylesheet" href="css/slicknav.min.css" type="text/css">
	    <link rel="stylesheet" href="css/style.css" type="text/css">
		<style type="text/css">
			.user_index{
				margin-top: 100px;
				position: relative;
			}
			.user_index2{
				position: absolute;bottom:20px;left:2%;width: 125px;border-radius:50%;overflow: hidden;border: 8px solid #fff;z-index: 10;padding: 0;
			}
			.user_index3{
				border: 1px solid #cecece;width: 100%;
			}
			.user_index4{
				padding: 10px;
				border-bottom: 1px solid #cecece;
				border-left: 1px solid #cecece;
				border-right: 1px solid #cecece ;
			}
			.i_span{
				display: inline-block;
				width: 30px;
				margin-right: 10px;
			}
			.i_span img{
				width: 100%;
			}
			a{
			text-decoration: none;
			}
		</style>
</head>
	<body>
		    <!-- Page Preloder -->
		    <div id="preloder">
		        <div class="loader"></div>
		    </div>
		    

			
    <!-- Header Section Begin -->
    <header class="header-section" style="position: fixed;top: 0;z-index: 99;width: 100%;">
        <div class="nav-item" style="position: relative;">
            <div class="container">
                <div class="nav-depart" style="position: fixed;left: 0;">
                    <div class="depart-btn">
                        <i class="ti-menu"></i>
                        <span><span style="color: #8fb0db;">Blue</span> VIDEO</span>
                        <ul class="depart-hover">
                            <li><a href="BlueVideoColle">我的收藏</a></li>
                            <li><a href="#">展览演出</a></li>
                            <li><a href="#">历史记录</a></li>
                        </ul>
                    </div>
                </div>
                <nav class="nav-menu mobile-menu">
                    <ul style="margin-left: 291px;">
                        <li><a href="BlueVideo">首页</a></li>
                        <li><a href="BlueVideoRec" style="border: none;">推荐</a></li>
                        <li>
                            <form action="SelectVideo" method="get">
                                <input class="primary-btn" type="text" id="username" name="selectvideo" style="margin-left:10px;background-color: #fff;color: black;border: none;">
                                <input class="primary-btn" type="submit" value="搜索" style="margin-right: 10px;margin-left: -4px;margin-top: 5px;border: none;">
                            </form>
                        </li>
                    </ul>
                    <ul style="position: fixed;right: -20px;">
                        <c:if test="${ user.user_name==null }">
                        	<li style="position: relative;"><a href="#" style="width: 100%;display: block;">
                            未登录
	                        </a>
	                        	<ul class="dropdown">
	                                <li><a href="BlueVideoLogin">去登录</a></li>
	                                <li><a href="BlueVideoReg">去注册</a></li>
	                            </ul>
	                        </li>
                        </c:if>
                        <c:if test="${ user.user_name!=null }">
                        <li>
                        	<a href="BlueVideoAdd">创作视频</a>
                        </li>
                        	<li style="position: relative;"><a href="#" style="width: 100%;display: block;">
                            <img src="img/UserImg/${ user.user_img }" style="position: absolute;top: 0;left: -20%;width: 38%;border-radius:100%;">
                            ${ user.user_name }
                            </a>
	                            <ul class="dropdown">
	                                <li><a href="BlueVideoUserIndex">个人信息</a></li>
	                                
	                                <li style="position: relative;">
	                                <a href="BlueVideoUserMsg">信息</a>
	                                <sql:query dataSource="${snapshot}" var="resultusermsgsum">
									SELECT COUNT(msg_log) AS usermsgsum FROM user_msg WHERE user_id = ${ user.user_id } AND msg_log = 1;
									</sql:query>
									
									<c:forEach var="rowusermsgsum" items="${ resultusermsgsum.rows }">
									<c:if test="${ rowusermsgsum.usermsgsum > 0 }">
									<div style="position: absolute;left:65px;top: 12px;background: red;border-radius: 50%;color: #fff;">
	                                	<div style="width: 25px;text-align:center;">${ rowusermsgsum.usermsgsum }</div>
	                                </div>
									</c:if>
	                                </c:forEach>
	                                </li>
	                                
	                                <li><a href="BlueVideoSeeUser?SeeUserid=${ user.user_id }">动态</a></li>
	                                <li><a href="BlueVideoUserMyVideo">我的视频</a></li>
	                                <li><a href="BlueVideoUserOut" style="color: #aaa000">退出登录</a></li>
	                            </ul>
	                        </li>
                        </c:if>
                    </ul>
                </nav>
                <div id="mobile-menu-wrap"></div>
            </div>
        </div>
    </header>
    <!-- Header End -->
			
			
			<c:forEach var="row" items="${ result.rows }">
			<div class="container user_index">
				<div class="row" style="position: relative;">
					<div style="background: rgba(0, 0, 0, 0.3);width: 100%;height: 100%;position: absolute;z-index: 2"></div>
					<div class="user_index2"><img src="img/UserImg/${ row.user_img }" alt="" style="width:100%;" /></div>
					<span style="position: absolute;bottom: 60px;left: 180px;color: #fff;z-index: 10;font-size: 30px;">${ row.user_name }</span>
					<div class="user_index3"><img src="img/user_bg.png" alt="" /></div>
				</div>
				<div class="row">
					<div style="width: 100%;" class="user_index4">
						<div class="login-form">
							<form action="BlueVideoUserIndex" method="post">
								<input style="display: none;" type="text" name="userid" value="${ row.user_id }">
								<div class="group-input">
									<span style="margin-left: 5px;">用户ID：${ row.user_id }</span>
								</div>
								<div class="group-input">
									<span class="i_span"><img src="img/用户.png" alt="" /></span>${ row.user_name }
								</div>
								<div class="group-input">
									<span class="i_span"><img src="img/地址.png" alt="" /></span>${ row.user_dress }
								</div>
								<div class="group-input">
									<span class="i_span"><img src="img/电话.png" alt="" /></span>${ row.user_number }
								</div>
							</form>
							
						</div>
						<div style="width: 100 %;">
							<button class="site-btn login-btn" style="width: 100%;margin-bottom: 50px;background:#6495ED;border-color: #6495ED;">${ row.user_name }的投稿</button>
								<div class="row">
								
								<sql:query dataSource="${snapshot}" var="resultvideouser">
									SELECT *  FROM video_table WHERE user_id = ${ SeeUserid } AND videoaudit = 0;
								</sql:query>
								
		                        <c:forEach var="rowa" items="${ resultvideouser.rows }">
		                            <div class="col-lg-4 col-sm-6">
		                                <div class="product-item">
		                                    <div class="pi-pic">
		                                        <img src="Video/${ rowa.videoimg }" alt="">
		                                        <div class="sale pp-sale">独家</div>
		                                        <ul>
		                                            <li class="w-icon active"><a href="#">${ rowa.videopf }</a></li>
		                                            <li class="quick-view"><a href="BlueVideoPlay?VideoID=${ rowa.videoid }">立即观看</a></li>
		                                            <li class="w-icon"><a href="#"><i class="fa fa-random"></i></a></li>
		                                        </ul>
		                                    </div>
		                                    <div class="pi-text">
		                                        <div class="product-price">
		                                            ${ rowa.videoname }
		                                        </div>
		                                    </div>
		                                </div>
		                            </div>
					            </c:forEach>
					            
		                     	</div>
						</div>
					</div>
				</div>
			</div>
			</c:forEach>
			
			
			
			
		    <!-- Js Plugins -->
		    <script src="js/jquery-3.3.1.min.js"></script>
		    <script src="js/bootstrap.min.js"></script>
		    <script src="js/jquery-ui.min.js"></script>
		    <script src="js/jquery.countdown.min.js"></script>
		    <script src="js/jquery.nice-select.min.js"></script>
		    <script src="js/jquery.zoom.min.js"></script>
		    <script src="js/jquery.dd.min.js"></script>
		    <script src="js/jquery.slicknav.js"></script>
		    <script src="js/owl.carousel.min.js"></script>
		    <script src="js/main.js"></script>
		
	</body>
</html>